UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EgJeFJXNq9cff6VCWvUGRGpWyjsyj3Um8IZf9+2/X58='
WHERE
key_id = '21730e936d15b71a37923c78687a0b07d51926af3d810968278fafb06de7c79a'
AND (
token = 'EgJeFJXNq9cff6VCWvUGRGpWyjsyj3Um8IZf9+2/X58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)