UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8fUeO1odHJXPDaQQoVVq9e30oW0TDaO3W2DT6J6WiuM='
WHERE
key_id = 'ec16126e5c499b7e3567ccb8d6bae40e87ee476d5df85f2fc5819a1121519c88'
AND (
token = '8fUeO1odHJXPDaQQoVVq9e30oW0TDaO3W2DT6J6WiuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)