UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hCa16oea23J4vbusiet/cN2zqaLqx4HCVzCmyCt26b4='
WHERE
key_id = '51423e5e99ccbee7bdc0f42bc1f8e837d36b63d8cd49897114b553d8a4992069'
AND (
token = 'hCa16oea23J4vbusiet/cN2zqaLqx4HCVzCmyCt26b4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)