UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+vND0VxYaph/90TRmKZWw/e/8oCGS18GNwHIi7xG6yE='
WHERE
key_id = '167e5958721c33b537c96277810386f7b2b4b520801a0ac4df1909d4ea1ade6c'
AND (
token = '+vND0VxYaph/90TRmKZWw/e/8oCGS18GNwHIi7xG6yE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)