UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NCzKm7O5GhtKUiqNR20aJTtABhejPDWTqHztQiDvW7E='
WHERE
key_id = '92124f4fb4f0b8514754a23baf216ff4fd3c1c7583a8b8718f25614c37303cf1'
AND (
token = 'NCzKm7O5GhtKUiqNR20aJTtABhejPDWTqHztQiDvW7E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)