UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't3eHmy9SAwnNbK5JZ/mxEc+wjNhkk7s1C/z8m4RsZQc='
WHERE
key_id = '029028b15db572f4afac78344ac31c3c6c914a7a04266b9f3bd6382f874f9b73'
AND (
token = 't3eHmy9SAwnNbK5JZ/mxEc+wjNhkk7s1C/z8m4RsZQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)