UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dXPlYZRC60hmWjRL1p7KWcictXrN54T44WH1TckCx1w='
WHERE
key_id = 'f3b3c9564b09f084608dc3e701115340bdf48f42bfb2ccf2c719b2b3527d12a5'
AND (
token = 'dXPlYZRC60hmWjRL1p7KWcictXrN54T44WH1TckCx1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)