UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wjyL7+gu10vvdC0jFaD/KCtOc2sAK+7SgD50/67Xh4g='
WHERE
key_id = '49186ca74e29941b4c9523d79a4d21d13d5b4eca5fed0951de28dd9d1de89289'
AND (
token = 'wjyL7+gu10vvdC0jFaD/KCtOc2sAK+7SgD50/67Xh4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)