UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xKyc+kDRig+sVVDp8tf78zOLqISpEZn9ABVYW0r8FzY='
WHERE
key_id = '2a8fd6bbb096d86cffc5d91317f95652d30cdff30252fbe70b48d6cc9975ec42'
AND (
token = 'xKyc+kDRig+sVVDp8tf78zOLqISpEZn9ABVYW0r8FzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)