UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+7pnf5RntprZ0q5dQ0JsZlB/H4WbzNu131npYA9PkCs='
WHERE
key_id = 'bd3b32e0c134a2f5eececeabb92ab2061f520e0dc9547fda7fb17d142c750c66'
AND (
token = '+7pnf5RntprZ0q5dQ0JsZlB/H4WbzNu131npYA9PkCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)