UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TgKdASf3bv0Dg6YGFEOt2DzvofxJ9t7x2YkBlqo5IoE='
WHERE
key_id = 'a34865cc2c423ef6e791d496e35dad59e145cd85738c86e6d7fc18fdff47594e'
AND (
token = 'TgKdASf3bv0Dg6YGFEOt2DzvofxJ9t7x2YkBlqo5IoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)