UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G9xWkh27zcexNgWsmnWsFp8ILjsdIPCnQb0yFEV8yHs='
WHERE
key_id = '058539f94789fad4c90d9539d0ea26c5ebecf9cd9652c4b24acc8bc2b1de211e'
AND (
token = 'G9xWkh27zcexNgWsmnWsFp8ILjsdIPCnQb0yFEV8yHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)