UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gsNy1AmDElvsBO0d1IkcOVFs+64sEyAETL/djN+T0IU='
WHERE
key_id = 'f50751cc2e9006f18fdc5f11baa23a9e724aca8674993cd7b274147c512cc7fe'
AND (
token = 'gsNy1AmDElvsBO0d1IkcOVFs+64sEyAETL/djN+T0IU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)