UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X+Z7ubyhDkCRPF7wyli6bIQl7uIcioloQWte07cVmww='
WHERE
key_id = 'e52ab4eacfdcbcdfa7ce6b49d751321f3ed752990cb8c346cd64f7e11a698aff'
AND (
token = 'X+Z7ubyhDkCRPF7wyli6bIQl7uIcioloQWte07cVmww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)