UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Zt8/7+WwHpO9iJLpGz/cA9+jtKna/xtLuusLZ8GmCs='
WHERE
key_id = 'ecc72027e99ea6368f05fb54134f0296a4d5d52b4118652e8f589614b23c4805'
AND (
token = '9Zt8/7+WwHpO9iJLpGz/cA9+jtKna/xtLuusLZ8GmCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)