UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hnaf6hS4xSMthOzld6IS0I2diDg2AOA7Qvr2nshwp5A='
WHERE
key_id = '591c2ab2b0e74d531d1dc3d8ff38b3905423b163567535dbdb21b508e93673d3'
AND (
token = 'Hnaf6hS4xSMthOzld6IS0I2diDg2AOA7Qvr2nshwp5A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)