UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bRd7k2+cZ95XmGHVuXvwveOdp29stdRBpCt8Z0UhtH8='
WHERE
key_id = 'cc2071256736a9ae71707822a37708e5497f561989aa1ba14c32a4dbfb53a07d'
AND (
token = 'bRd7k2+cZ95XmGHVuXvwveOdp29stdRBpCt8Z0UhtH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)