UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ij8acREp4A4B3AKcCnB/PLTyACVwsxsm0t9ygNgzu8='
WHERE
key_id = 'e96a6465b35dd075010e3d11f05b3c0941d000123a2e5bd5dbc7f91b6ac437cc'
AND (
token = '0ij8acREp4A4B3AKcCnB/PLTyACVwsxsm0t9ygNgzu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)