UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P6S0RXyQSnuAuyzV7OFp3ArAj8EBuSHw355qYLghirw='
WHERE
key_id = '55356a369ffa0d8c64241ac463bdf465d274ef762d6d0605cf973153b540b126'
AND (
token = 'P6S0RXyQSnuAuyzV7OFp3ArAj8EBuSHw355qYLghirw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)