UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KRmw7GQ8wDxv/A/zVwTC6TnBZbbFjOsbSatmduKIsTs='
WHERE
key_id = '5041b3eb9644ae2a665ba0c90f864f7b6792cd9a7904debf42b1d3b877d5c727'
AND (
token = 'KRmw7GQ8wDxv/A/zVwTC6TnBZbbFjOsbSatmduKIsTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)