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