UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k4ZLbdFoFj0tARTdRtb9OtzgPHoot9GWZJxhq1u3tZo='
WHERE
key_id = 'ad6c47a9e78775934e0f17e4e656c5c7c768be6ee88f308cc1e7fcd76975c230'
AND (
token = 'k4ZLbdFoFj0tARTdRtb9OtzgPHoot9GWZJxhq1u3tZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)