UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D9W2wlyNEMbaRV7KUMSGA92NWyNXiC2LnQTV1BZpavA='
WHERE
key_id = '0a1ab6e29aebf3288095ac8f0ddf974ae40d055419627d1c66045577e7429971'
AND (
token = 'D9W2wlyNEMbaRV7KUMSGA92NWyNXiC2LnQTV1BZpavA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)