UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hiZg64pDo5SFAauUT2/NdIsf/8f4hqtXXXxHSsxlh3Q='
WHERE
key_id = 'ecddf28a1112bc47bb537941d93e638afb5b349609dc4ce37cf3de91fd5692f7'
AND (
token = 'hiZg64pDo5SFAauUT2/NdIsf/8f4hqtXXXxHSsxlh3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)