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