UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zfOwI7qeWBv/8iKitFaTFWeVYH8M3Nzqr+sh0mfAoW4='
WHERE
key_id = '8c533625c1c6df0a04d9a101029b490b38e96ba36806147a3934d05a238bea20'
AND (
token = 'zfOwI7qeWBv/8iKitFaTFWeVYH8M3Nzqr+sh0mfAoW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)