UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JSKDQHgUigYcqaFmb07C2le1GpKg3NJcRysTdIlfVV4='
WHERE
key_id = '47570fab7567e6e9d33152a827d73e39aedf0897355fca4a6dd0ce276d25529e'
AND (
token = 'JSKDQHgUigYcqaFmb07C2le1GpKg3NJcRysTdIlfVV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)