UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yJDBtjQLRqT7RVwMr9ebdjLF0eEqM7V/tzYjtPPeO4A='
WHERE
key_id = 'ccc57c711c9e1ff91ceacd35e90ecb3d62baea2ebbd29c6b25c2409209039c8a'
AND (
token = 'yJDBtjQLRqT7RVwMr9ebdjLF0eEqM7V/tzYjtPPeO4A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)