UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e0ObQsz/eozmkz0Z2UruWqGj58xh/aGdm5MmNn1VIfo='
WHERE
key_id = '3f3339a00a034ac005084db42d769851716cc71374e75fb894996b796582c3a8'
AND (
token = 'e0ObQsz/eozmkz0Z2UruWqGj58xh/aGdm5MmNn1VIfo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)