UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '71EmU5y58i5q9bXK6hDjFl+U2s3ikrUOviJFUL/6U5E='
WHERE
key_id = 'c1d18c3052dcb4d344de6b0b11a7d617a58eb75b8cdc9aea36deb44ca67f341b'
AND (
token = '71EmU5y58i5q9bXK6hDjFl+U2s3ikrUOviJFUL/6U5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)