UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'InQ2MmNLibI3WnKX99NwbgWLxJN7WyLv++PDE/oM3iw='
WHERE
key_id = '9f997676687d12a1e855ca3a6c7f24ded224e571bb035b4341b3d5188b6edbaf'
AND (
token = 'InQ2MmNLibI3WnKX99NwbgWLxJN7WyLv++PDE/oM3iw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)