UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tvENOvIZB+GVpgxuRC/ZPuIfosHdqVYwetWdMnUQdzA='
WHERE
key_id = 'be304badd67fb2f03a6fdf3036e8a37e85b2769b41a447b4cb5cc581fd3d5f59'
AND (
token = 'tvENOvIZB+GVpgxuRC/ZPuIfosHdqVYwetWdMnUQdzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)