UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '243/slxrUK9Uwes9FMFYZbH0ssziYPghbRsPaonX0og='
WHERE
key_id = '0935074c41acfd77658c34fff79ce1d0b3a4c9e802a40811310ed50599a40349'
AND (
token = '243/slxrUK9Uwes9FMFYZbH0ssziYPghbRsPaonX0og='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)