UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZtmaOPvRcCFRB39GPmMBzxMOXZYeuIX6Wi6OTwOPEO4='
WHERE
key_id = '38ce38eff8b3b0e2bfda13b279b08bc0c8ccc026dc4ce39be7c19f0536b7cfd2'
AND (
token = 'ZtmaOPvRcCFRB39GPmMBzxMOXZYeuIX6Wi6OTwOPEO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)