UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6C4XIxTMhKjW/bcGSoWt49M3rT7005zcLWFJZX40DlQ='
WHERE
key_id = 'c2f53e1658f6ab157724283fdca5c11fb8fd67618db96dff26d8884314754e89'
AND (
token = '6C4XIxTMhKjW/bcGSoWt49M3rT7005zcLWFJZX40DlQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)