UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pM+F0TBq4HDb99mRZq4OSKKb92FBtrHg+dYm0JspcJU='
WHERE
key_id = '47db140c5d8acda34c18a5abb45fa6d9d6f71bd53eb0386abc267e05be21cb90'
AND (
token = 'pM+F0TBq4HDb99mRZq4OSKKb92FBtrHg+dYm0JspcJU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)