UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p16vD7o+/W3t9qeQnU4J0tF7b1fOJVOZIAmK767MhJU='
WHERE
key_id = '2a3a9156f94037b96fd97a24401d4261a2cb2ceb8453814907ed0b15a9600b9b'
AND (
token = 'p16vD7o+/W3t9qeQnU4J0tF7b1fOJVOZIAmK767MhJU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)