UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CqFS9y9Xw9i3+Du46Ozw+PH25Z2hogNbMAdrb8RfeTs='
WHERE
key_id = 'f7bdc05b47d34bb59612be05ce853c5462ee681edd738abeb8af1c16821387f5'
AND (
token = 'CqFS9y9Xw9i3+Du46Ozw+PH25Z2hogNbMAdrb8RfeTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)