UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ROZ15SZ641w2lYmPBjHD0DvtqjusjC668m13BBNQDec='
WHERE
key_id = '5041a3324ca5790a2d22a49f4d89573b57e88e38f25cf204019f922967d1dbd5'
AND (
token = 'ROZ15SZ641w2lYmPBjHD0DvtqjusjC668m13BBNQDec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)