UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6HugnRGzALY05X8kLjcu/uV1Y7xVj57QNGUFkSnU6FU='
WHERE
key_id = '485a2441857fd592c0ad7c9cf26fad2c7b292e6821450e5e1c3a9971d2ec7be4'
AND (
token = '6HugnRGzALY05X8kLjcu/uV1Y7xVj57QNGUFkSnU6FU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)