UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XE/j3s29mcUPy2Pa6DPLCVYagscjcRuJM/Jwi1IBi5A='
WHERE
key_id = 'e692315a667a69bb34dd132444d1dea314b7a342dd6bf172b2f5d144f9a3120e'
AND (
token = 'XE/j3s29mcUPy2Pa6DPLCVYagscjcRuJM/Jwi1IBi5A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)