UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yU3GYJ5XgJMJzIsmS0Juewp62QBWX+b2vBmVaToI3YE='
WHERE
key_id = 'ca6e6b581826ae2d537514600d7f7e1e47b31bc18b456cc5255257cf4efd273f'
AND (
token = 'yU3GYJ5XgJMJzIsmS0Juewp62QBWX+b2vBmVaToI3YE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)