UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LPmZ14yHVFkozCOF4HcIQE4eQqXBI9gxQHRF201yHOw='
WHERE
key_id = '6f666aa870e232f8845eedb60c49690d61bb6000af3c884c2669ff7479525cb3'
AND (
token = 'LPmZ14yHVFkozCOF4HcIQE4eQqXBI9gxQHRF201yHOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)