UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0y00HPlO4UaOay7dNLMomxovflN+4sEBD/iqMstJHY8='
WHERE
key_id = 'cd6506264635f489abc931ca2d82291f0fcfca788750d77a3378dbb7a8826b75'
AND (
token = '0y00HPlO4UaOay7dNLMomxovflN+4sEBD/iqMstJHY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)