UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'haY5/5LItIRG9InUGFStjLJXRITKmNwUrReLRY1FAYs='
WHERE
key_id = '56ec493924c3cc227c487494591ec0257a7337e0b039c3f876616d2f72c78f3e'
AND (
token = 'haY5/5LItIRG9InUGFStjLJXRITKmNwUrReLRY1FAYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)