UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qbCaWVKyIWp5ni+ePMDy5bgR21ReJjTyKCJcDM8mJ54='
WHERE
key_id = '18b35f7ebce8b4d255cc241c6037d1f30223e7bd69da3f1550a0c2678ee68b7e'
AND (
token = 'qbCaWVKyIWp5ni+ePMDy5bgR21ReJjTyKCJcDM8mJ54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)