UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H9xhi71yyeTW8XHK1qCkbx3WzntAXT3/aW2C/cH3sRk='
WHERE
key_id = '2971f94081706b9901cd218caa014fd72332506606c96da8da0b139d39085061'
AND (
token = 'H9xhi71yyeTW8XHK1qCkbx3WzntAXT3/aW2C/cH3sRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)