UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TI3vppMOSYFQhvQ/CK5AlXjG/JaoBxvn12yn26XezgI='
WHERE
key_id = '538d637d20738d07bb5c5231e87b07e19aa2c9819e051d3637fa851ce25ed8da'
AND (
token = 'TI3vppMOSYFQhvQ/CK5AlXjG/JaoBxvn12yn26XezgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)